Below is a description of elements' concepts, procedures, special automatic processes and dependencies in Innovator for Database Architects.
Innovator for Database Architects is used for modeling, optimizing and implementing relational databases. Two model levels are used for this, the conceptual schema and the database schema.
Conceptual data modeling is carried out using entity relationship models; diagrams can be edited using different notations depending on what the user chooses. The aim is to create a normalized model which is free of redundancies and contains domain data.
The database schema is the model for storing data in a relational database system. The aim is to realize and maintain the structure of the tables in a concrete database. The database can be described fully for maintenance by the database administrators; this is done by denormalizing tables and creating elements which are typically found in databases, such as indices, user management, data organization etc.
Mapping creates the interaction between conceptual and database schema. A DB model is created and maintained from an ER model in a top-down process (database design). An ER model is created from a DB model in a bottom-up process (reverse engineering); this is the basis for further development of domain requirements.
Database schemata are realized and compared with a concrete database using JDBC or DDL scripts in SQL syntax.
Innovator X Generation 11 R4 - Copyright © 2011-2012 - MID GmbH Nuremberg - DIN EN 9001 certified - All rights reserved.